Nevertheless Another portion I'm having difficulties to accomplish following the mass copy and paste has operate I want another code that will update column A appropriately these kinds of which the Work num from sheet two will fill in to every between duties 2 and 10,000 I have hooked up Successfully Submitted (Awaiting Approval)